import os
from flask import Flask
from flaskr.models.schema import db, User, Post

def create_app(test_config=None):
    print("Creating the app...")
    # create and configure the app
    app = Flask(__name__, instance_relative_config=True)
    
    # config MySQL database
    app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql+pymysql://root:lxw123@localhost:3306/flaskr'
    # init app with extension SQLAlchemy
    db.init_app(app)
    # create tables
    with app.app_context():
        db.create_all()

    # Load configuration
    app.config.from_mapping(
        SECRET_KEY='dev',
        DATABASE=os.path.join(app.instance_path, 'flaskr.sqlite'),
    )
    
    if test_config is None:
        # load the instance config, if it exists, when not testing
        app.config.from_pyfile('config.py', silent=True)
    else:
        # load the test config if passed in
        app.config.from_mapping(test_config)

    # Ensure the instance folder exists
    try:
        os.makedirs(app.instance_path)
    except OSError:
        pass

    # A simple page that says hello
    @app.route('/hello/')
    def hello():
        return 'Hello, World!'
    
    from . import auth
    app.register_blueprint(auth.bp)
    
    from . import blog
    app.register_blueprint(blog.bp)
    app.add_url_rule('/', endpoint='index')

    return app